CREATE PROCEDURE sp_asi_NameToNameAddressSync (
  @ID VARCHAR(10)
  )
  AS
  UPDATE Name_Address SET
  PHONE = (
  SELECT HOME_PHONE FROM Name WHERE ID = @ID
  )
  WHERE ID = @ID
  AND PURPOSE = (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName =
  'Member_Control.' + (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName = 'Member_Control.SyncHomePhoneToAddress'
  ) + 'Prompt'
  )
  UPDATE Name_Address SET
  PHONE = (
  SELECT WORK_PHONE FROM Name WHERE ID = @ID
  )
  WHERE ID = @ID
  AND PURPOSE = (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName =
  'Member_Control.' + (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName = 'Member_Control.SyncWorkPhoneToAddress'
  ) + 'Prompt'
  )
  UPDATE Name_Address SET
  FAX = (
  SELECT FAX FROM Name WHERE ID = @ID
  )
  WHERE ID = @ID
  AND PURPOSE = (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName =
  'Member_Control.' + (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName = 'Member_Control.SyncFaxToAddress'
  ) + 'Prompt'
  )
  UPDATE Name_Address SET
  EMAIL = (
  SELECT EMAIL FROM Name WHERE ID = @ID
  )
  WHERE ID = @ID
  AND PURPOSE = (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName =
  'Member_Control.' + (
  SELECT ShortValue FROM System_Params
  WHERE ParameterName = 'Member_Control.SyncEmailToAddress'
  ) + 'Prompt'
  )

GO
GRANT EXECUTE ON  [dbo].[sp_asi_NameToNameAddressSync] TO [IMIS]
GO